<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Enabling drilling in an Interactive Bubble Graph widget</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
p.whs1 { margin-left:40px; }
img_whs2 { border:none; width:382px; height:203px; float:none; border-style:none; }
p.whs3 { margin-left:0px; }
ul.whs4 { list-style:disc; }
p.whs5 { font-weight:normal; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs3 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying documents and dashboards\nProviding Flash-based analysis and interactivity: Widgets\nCreating an Interactive Bubble Graph widget\nEnabling drilling in an Interactive Bubble Graph widget");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Enabling drilling in an Interactive Bubble Graph widget</h1>
<p>When you use an Interactive Bubble Graph widget in a document, you can 
 choose to enable drilling on the graph by adding one additional attribute 
 (a second attribute) to the right of the attribute in the rows of the 
 associated Grid/Graph. This second attribute must be a child attribute 
 of the parent attribute already on the rows. For example, in the image 
 below, the parent attribute is Region and the Call Center Custom Group 
 attribute is the child attribute. </p>
<p>To enable drilling on the graph, the child attribute must be structured 
 in a specific way. This structure is best attained by using a custom group. 
 For information on creating custom groups in Desktop, see the <span style="font-style: italic;"><I>MicroStrategy 
 Advanced Reporting Guide</I></span>. The data in the grid for the child attribute 
 must be displayed so that the total for the child attribute is in the 
 top row of data, followed by the data for the child attribute. A custom 
 group allows you to easily ensure that this occurs. An example of this 
 type of data in grid form is shown below. In the custom group, notice 
 that the first element within the Northeast region is Northeast. This 
 is followed by the two child attribute elements, Boston and New York. 
 </p>
<p>To enable both drilling and time series animation in an Interactive 
 Bubble Graph widget, you must have at least three attributes on the rows 
 of the associated Grid/Graph. The attribute on the left must be an attribute 
 associated with time, and the second and third attributes must have a 
 parent/child relationship as described above. For more information about 
 enabling time series animation, see 
<a href="Bubble_time_series.htm">Enabling 
 time series animation in an Interactive Bubble Graph widget</a>.</p>
<p>In the metric data, the first row represents the total (Average for 
 the first two metrics, Sum for the third) of the other two rows. The first 
 row must include totals for drilling to work properly. </p>
<p class="whs1"><img src="images/widget_drillbubblegrid.gif" x-maintain-ratio="TRUE" width="382px" height="203px" border="0" class="img_whs2"></p>
<p class="whs3">Instead of creating a custom group, you can 
 add subtotals, without grand totals, when you create the original report. 
 The subtotals must be calculated by row and must be displayed at the top 
 of each level. This ensures that the total for the second attribute is 
 displayed in the top row of data, followed by the data for that attribute. 
 Be sure to add the Grid/Graph to the document with formatting, so that 
 this structure is used. </p>
<p>Once the Grid/Graph contains the necessary objects, you must switch 
 to Flash Mode or Interactive Mode to enable drilling within the widget. 
 To do so, right-click the widget, select <span style="font-weight: bold;"><B>Properties 
 and Formatting</B></span>, select <span style="font-weight: bold;"><B>Grid</B></span><span> 
 from the left, and then select an option from the </span><span style="font-weight: bold;"><B>Drilling 
 </B></span><span>drop-down list. Click </span><span style="font-weight: bold;"><B>OK 
 </B></span><span>to save your changes and close the dialog box. </span>&nbsp;</p>
<p>To summarize, the Grid/Graph's requirements for an Interactive Bubble 
 Graph with drilling enabled are:</p>
<ul type="disc" class="whs4">
	
<li class=p><p>If you are only enabling drilling, &nbsp;second 
 attribute must be placed to the right of the first attribute on the Grid/Graph 
 rows. </p></li>
	
<li class=P-TopicTextBulleted2><p class=TopicTextBulleted2>This attribute 
 must be the child attribute, while the first attribute is the parent attribute. 
 </p></li>
	
<li class=P-TopicTextBulleted2><p class=TopicTextBulleted2>This second 
 attribute must have a specific data structure so that the first grid row 
 displays the total for the child attribute. This is best achieved by using 
 a custom group, as described above. </p></li>
	
<li class=p><p>If you are enabling drilling and time series animation, 
 a total of three attributes must be in the Grid/Graph rows</p></li>
	
<li class=P-TopicTextBulleted2><p class=TopicTextBulleted2>The first 
 attribute must be based on time to enable time series animation</p></li>
	
<li class=P-TopicTextBulleted2><p class=TopicTextBulleted2>The second 
 attribute must be the parent attribute</p></li>
	
<li class=P-TopicTextBulleted2><p class=TopicTextBulleted2>The third 
 attribute must be the child attribute with a specific data structure so 
 that the first grid row displays the total for the child attribute. This 
 is best achieved by using a custom group, as described above.</p></li>
	
<li class=p><p class="whs5">Enable drilling on the 
 widget in Flash Mode or Interactive Mode. To do this, right-click the 
 Interactive Bubble Graph widget, select Properties, select the <span style="font-weight: bold;"><B>Drilling 
 </B></span><span>tab, and then </span>select the <span style="font-weight: bold;"><B>Enable 
 drilling</B></span> check box. Click <span style="font-weight: bold;"><B>OK</B></span><span> 
 to save your changes and close the dialog box. </span></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
